<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="备份前准备">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="SAP_ON_ORACLE_0009.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="SAP_ON_ORACLE_0012">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>备份前准备</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="SAP_ON_ORACLE_0012"></a><a name="SAP_ON_ORACLE_0012"></a>

<h1 class="topictitle1">备份前准备</h1>
<div><p>备份SAP on Oracle数据库前，请参考<a href="#SAP_ON_ORACLE_0012__zh-cn_topic_0000001455091930_table10744125193920">表1</a>提前准备相关信息。</p>

<div class="tablenoborder"><a name="SAP_ON_ORACLE_0012__zh-cn_topic_0000001455091930_table10744125193920"></a><a name="zh-cn_topic_0000001455091930_table10744125193920"></a><table cellpadding="4" cellspacing="0" summary="" id="SAP_ON_ORACLE_0012__zh-cn_topic_0000001455091930_table10744125193920" frame="border" border="1" rules="all"><caption><b>表1 </b>备份前准备</caption><colgroup><col style="width:19.64%"><col style="width:61.85000000000001%"><col style="width:18.509999999999998%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="19.64%" id="mcps1.3.2.2.4.1.1"><p>准备项</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="61.85000000000001%" id="mcps1.3.2.2.4.1.2"><p>获取方式</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="18.509999999999998%" id="mcps1.3.2.2.4.1.3"><p>数据使用章节</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="19.64%" headers="mcps1.3.2.2.4.1.1 "><p><span style="color:#4D4D4D;">SAP实例ID</span></p>
</td>
<td class="cellrowborder" valign="top" width="61.85000000000001%" headers="mcps1.3.2.2.4.1.2 "><p><a href="SAP_ON_ORACLE_0007.html#SAP_ON_ORACLE_0007__section17145114099">背景信息</a>的“SAPSID”。</p>
</td>
<td class="cellrowborder" rowspan="3" valign="top" width="18.509999999999998%" headers="mcps1.3.2.2.4.1.3 "><p><a href="SAP_ON_ORACLE_0014.html">步骤1：注册SAP on Oracle数据库</a></p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.4.1.1 "><p><span style="color:#4D4D4D;">Oracle实例ID</span></p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.2.2.4.1.2 "><p><a href="SAP_ON_ORACLE_0007.html#SAP_ON_ORACLE_0007__section17145114099">背景信息</a>的“DBSID”。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.2.2.4.1.1 "><p>数据库用户名及密码</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.2.2.4.1.2 "><p>执行<a href="SAP_ON_ORACLE_0007.html#SAP_ON_ORACLE_0007__section09572159441">启动数据库并创建数据库用户</a>时创建的用户名和密码。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" width="19.64%" headers="mcps1.3.2.2.4.1.1 "><p>数据库状态</p>
</td>
<td class="cellrowborder" valign="top" width="61.85000000000001%" headers="mcps1.3.2.2.4.1.2 "><p>检查数据库是否为“OPEN”状态。</p>
<ol><li>进入<a href="SAP_ON_ORACLE_0007.html#SAP_ON_ORACLE_0007__section10539810434">手动创建run文件夹和拷贝文件</a>创建的run目录，例如：<pre class="screen">C:\&gt;cd usr\sap\EH7\SYS\exe\run</pre>
</li><li>执行以下命令，查看Instance status (status)的值。若值为“OPEN”，表示数据库为“OPEN”状态。<pre class="screen">brspace -c force -l E -u <em>userName</em>/<em>passWord</em> -f dbshow -c dbstate</pre>
<div class="p">其中，“userName”和“passWord”为<a href="SAP_ON_ORACLE_0007.html#SAP_ON_ORACLE_0007__section09572159441">启动数据库并创建数据库用户</a>中创建的数据库用户名和密码。例如：<pre class="screen">C:\usr\sap\EH7\SYS\exe\run&gt;brspace -c force -l E -u user1/Test123 -f dbshow -c dbstate
BR1001I BRSPACE 7.40 (1)
BR1002I Start of BRSPACE processing: sfqavhbp.dbw 2024-12-24 07.39.25
BR1301W Error message from likeywlib:
......
-----------------------------------------------------------Information about the status of database instance EH7
 1 - Instance number (number) ........... 1
 2 - Instance thread (thread) ........... 1
 <strong>3 - </strong><strong>Instance status (status) ........... OPEN</strong>
 4 - Instance start time (start) ........ 2024-12-24 07.33.45
 5 - Oracle version (version) ........... 11.2.0.3.0
 6 - Database creation time (create) .... 2024-10-24 10.38.10
 7 - Last resetlogs time (resetlogs) .... 2024-10-24 10.38.10
 8 - Archivelog mode (archmode) ......... ARCHIVELOG
 9 - Archiver status (archiver) ......... STARTED
10 - Current redolog sequence (redoseq) . 111
11 - Current redolog SCN (redoscn) ...... 9034696
12 - Flashback status (flashback) ....... OFF
13 - Block change tracking (tracking) ... OFF
14 - Data encryption (encryption) ....... OFF
15 - Database vault (dbvault) ........... OFF
16 - Number of SAP connections (sapcon) . 0
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0280I BRSPACE time stamp: 2024-12-24 07.39.26
... ...</pre>
</div>
</li><li>若数据库为非Open状态，执行以下命令，开启数据库。<pre class="screen">sqlplus / as sysdba
startup;</pre>
</li></ol>
</td>
<td class="cellrowborder" valign="top" width="18.509999999999998%" headers="mcps1.3.2.2.4.1.3 "><p>-</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="SAP_ON_ORACLE_0009.html">备份</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>